package com.jandar.spider.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ContentBiddingStatisticsMapper {

    @Select("select max(pubDate) from content_bidding ")
    Long getMaxPubDateByProvince(String province);

    @Select("select count(id) from content_bidding where province=#{province}")
    Integer getCountByProvince(String province);

    @Select("select count(id) from content_bidding")
    Integer getCount();

    @Select("select count(1) from content_bidding where code in (select code from content_bidding group by code having count(1) > 1)")
    Integer getRepeatCount();
}
